Required permissions

To use a Microsoft Azure SQL Managed Instance source in a Qlik Replicate task, the user specified in the Microsoft Azure SQL Managed Instance endpoint connection settings must be a member of the db_owner database role.

To use the db_owner database role, the following permissions are required on the master DB:

• grant view any definition
• grant view server state
• grant execute on sp_repldone
• grant execute on sp_replincrementlsn
• grant execute on sp_addpublication
• grant execute on sp_addarticle
• grant execute on sp_articlefilter
• grant select on sys.fn_dblog